Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

Allocating cursors

ORACLE allocates a maximum number of cursors that your application can use based on system configuration, the version of ORACLE, and the database-configuration parameters. An application can run out of available cursors. If this occurs, you can specify that ORACLE should allow more cursors, or you can control how many cursors the DataServer uses with the Index Cursor (-c) connection parameter. See the "Index cursors" section for more information.

Issuing the CLOSE QUERY statement after opening a query is another technique that you can use to help minimize the number of cursors your application requires.